In my household we do not trust the tap and would never drink from it directly. We have something called hard water here and came here from New Mexico where our tap was frequently brown. Both were “safe” to drink, but we choose to drink neither directly.
We buy 20 ounce water bottles from the grocery store which are filled from the “local” spring. We keep a Brita water filter pitcher in our fridge that we fill out of the tap and replace the filter on regularly. Generally we each open a new bottle in the morning and then refill it from the brita filter for the remainder of the day.
I drink directly from the tap, and grew up trusting my access to water. Now, I'm aware that not everyone has that privilege and our government, increasingly neoliberal and enamored with privatization and fracking, has allowed the public freshwater infrastructure to degrade in various parts of the country that didn't previously have problems with their tap water.
It's one of the first questions I ask when I visit someone else now. It's probably the greatest modern civilizational decline.
A lot of people mention Brita filters, which is an activated carbon filter, however a lot of households would probably benefit more from limescale filters.
That said, water purification is big business. People have filtered water pitchers (think Brita) or large units that supply the whole house (Culligan)
Oddly, I recall that the "workaround" solution being to the Flint crisis was to ship in tons of bottled water. Cheap filters, if they remove lead and bacteria fully, would seem like a much more cost effective way.
From what I've seen Germans seems pretty suspicious of their tap water(or maybe just hard water?) and use brita filters a lot. There is no actual health benefit or harm avoidance for using them as far as I understand.
Here are some of the popular brands that you can get over here:
https://www.eurekaforbes.com/water-purifiers/by-category/aqu...
These claim to use RO, UV etc. for purifying the water. I am kind of surprised that the Amazon USA listings for water purifiers return several fad-ish "gadget" things first, instead of the above.