Hi there, I enjoyed reading your post. I'm a water management consultant and so I have a strong affinity to water. As you said, water is mismanaged leading some places to suffer from drought and others from floods.. With proper water management both these problems can be solved
It pains me to see so many people wasting water, and others suffering from losing what little precious water they have. If we use and manage our water when it comes, we can always have enough.

I'm doing my best to try and share this information with as many people as possible.

As for your contaminated water, there are a number of simple home made DIY filters that can filter and produce drinking water for free.

here's a link to a simple set up from a few barrels, some rocks gravel and earth

If you'd like to know more I'd be happy to answer any questions you may have.

I believe water will be our number 1 concern in the coming future, until we all learn to value and cherish the precious water we receive freely from the sky.

All the best!