If it’s only air it just gets cloudy, not discolored.
It can be disolored from iron, and that’s not a health problem AFAIK.

I have never heard of anybody here in Denmark who has brown or cloudy tap water. That would simply not be considered acceptable.
Tap water here is always CRYSTAL clear, and generally higher quality than bottled water.