I know about an interesting Mantra from the Vedas which is probably giving an indication to the amount of water we should intake.
samAni prapA saha vonnabhAgah ||
May your water drinking equal your food intake (anna).
Atharva Veda 3.30.3
Apart from that it is also not recommended that we use frothy water (i.e with bubbles) while we are sipping water for Achamana. So, water which has bubbles in it (like the soft drinks have) is obviously considered as impure and drinking such water must also not be recommended.
Manu Smriti 2.61. He who knows the sacred law and seeks purity shall
always perform the rite of sipping with water neither hot nor
frothy, with the (prescribed) tirtha, in a lonely place, and turning
to the east or to the north.
I think it's believed that water also accepted to share Indra's guilt of slaying Vritta (who was a Brahmin) and that sin/impurity stays in the bubbles of the water.
These are the only rules of water consumption, in general, that I'm aware of.
For the Yogis, in particular, the Hatha Yoga Pradipika says that the Yogi should consume only pure water.
Varjayeddurjanaprāntam vahnistrīpathisevanam |
kāyakleśavidhim tathā ||
Wheat, rice, barley, shâstik (a kind of rice), good corns, milk, ghee,
sugar, butter, sugarcandy, honey, dried ginger, Parwal (a vegetable)
the five vegetables, moong, pure water; these are very beneficial to
those who practise Yoga