The entire city of pittsburg has ongoing lead in tapwater scandals. To a lesser extant so has the entire state of Milwaukee.
That is already millions, but...
Flint still has problems. Brady Texas has radium, Washington DC has intermittently had Lead. It is entirely on well owners to test and maintain their own water. New Jersey leads the country in BPA in water, some of which is safe, but the advice is to check with each municipality if it is safe....
And so on for all kinds of places and reasons. We just don't take tap water seriously as a country even though it wouldn't be a hard problem for us to solve.
Palo Alto Park Mutual Water Company, deserving about 600 houses, in the middle of the Silicon Valley. Water is not potable.
I have an extensive filtration system for making it potable. It is expensive, but the convenience is worth it as I can afford it. My neighbor has to go out refill 18L jugs for his drinking supply.