The mayor of a French village has been castrated and murdered by a man who suspected he was having an affair with his girlfriend.