If I travel to the US (Let's say Los Angeles, Seattle and New York) how do I know if the tap water is safe to drink? In the EU I normally just ask a local. In Germany it's safe to drink but in the Czech Republic you might be better off drinking bottled water (last time I checked was ~10 years ago, sorry if it's changed).
Unless you're in Flint, or a paranoiac, tap water in the US is safe. Period.
Flint's problem is not endemic, it was isolated. The article is really reaching - they cite 3 instances over ~15 years of problems in city water supplies. In 2 of the 3 cases it was caught and rectified quickly - Flint is the exception.