Primary source: Diverse.
Most likely: in groundwater from chemicals washed out of soil particles or rocks; in surface water most likely from microbial activity. In anaerobic groundwater HsS often cause of bad smell.
Effect: Does not necessarily have an adverse health effect, but - depending on the color or smell - may be an indication of another contamination sort