Someone who puts an end to others' fun, especially harmless fun.
Like a spoilsport.
One with strong moral views against excessive consumption of alcohol, gambling, pornography, etc., who seeks to promulgate those views.