I used to drink the water out of the creeks when I lived in a rural environment, and that was water that livestock waded in, and probably pissed in as well. I survived. The water that comes into my house is pumped out of the Mississippi River, and there is stuff in that river that means you don’t ever eat the fish you catch in it.
so is the water harmful?
Probably just as harmful as the air, which is full of mercury and other junk from automobiles, diesel trucks and coal burning power plants. No matter what you do, something will get you. I bet even the Bubble Boy™ eventually dies of something. Life is fatal, ya know.