A few places in the US have tap water that tastes famously bad, largely due to where they get the water from. San Diego is a famous example. The water is safe and clean but discolored and the flavor is pretty awful.

Much of the US has great tasting tap water.