Dirty water was dirty, because it was from a wild stagnant spring, it was visually muddy or something. That being said, it turned out to be drinkable.
Well water was contaminated with some animal/human disease. Probably cholera, as it is the standard one.
The cultists were crazy cultists, but...