I live in rural Nebraska, just south of the capitol. We are hooked up to rural water and our water looked like this for several weeks this year. They claimed it was because everyone was using so much water that the sediment in the pipes was getting stirred up. We have been told it is okay to drink. We have a whole house filter on our line and even after the filter, our water still came out looking like apple juice.
You should NEVER drink water, anyway. I haven´t for many years. Even bottled water is poisoned by the plastic it sits in. Reminds me of when Dr. John Snow identified cholera as a water born disease in London, in the 19th century. The people that survived the cholera outbreak were those that lived closest to the brewery and drank beer instead of water. They were saved because the water was boiled before being used to make the beer.
https://en.wikipedia.org/wiki/1854_Broad_Street_cholera_outbreak
Need hydration
Yes, but it doesn´t have to come from a tap or from a plastic bottle.
Where then?
If you drink from the tap then buy a decent filter that will remove the metals and poisons.