We have fairly good water, although it is very hard. Bought this house as new construction back in 2002 and had to replace the water heater in 2009 because the water heater got plugged up from calcium deposits. The water here is so hard that the water quality report doesn't even report how hard the municipal water is.
NYC actually gets all of their water from up in the mountains here and it has always been touted as some of the best water in the country. Problem is though they get all their water through two underground aqueducts that are over a hundred years old and they are leaking millions of gallons of water a year. For one town that is built on top of one of the major leaks, many of the houses flood on the regular basis and NYC actually had to
buy out a lot of the homeowners. They can't just shut the aqueduct down to repair the leaks since it would cut off half of the water used by NYC. You have to admit though, that the NYC aqueducts are a feat of engineering. They do not use any pumps at all, and all the water travels the 100 miles plus down to NYC and builds up the pressure necessary to send water up hundreds of floors in the skyscrapers all by gravity.