>My parents live in a medium sized Texas city that has tap water that is typically brown, sometimes it comes out of the tap foamy

Source/pictures? I find it hard to believe such water would be allowed by the EPA. This is also strange, considering that I've been to countries without drinkable tap water (eg. you have to boil it), and the water doesn't look like that.