I have long argued that the effluent from waste treatment should be discharged upstream, not downstream. A very few miles of tumbling in an open stream will render the scrubbed water ready for use.
You don't believe that, Raleigh? Ask Smithfield.
And now technology makes it even better. It'll be just like those SyFy stories about reclaiming water on space stations all too soon.