Residents of Castlewood said Bryon Noem was a supportive spouse who shied away from being in the limelight