Sniping is a method of killing. The term for someone who kills people in that way is a sniper. The same way that someone who detonates bonbs is a bomber.

I've never heard of any other context where executioners are regarded as heroes. Maybe people to be treated with respect for doing a job that is seen as necessary, "a dirty business, but someone's got to do it".