Reverse osmosis is the next goldmine opportunity. Every home will likely need one, or maybe there will be neighbourhood nodes. It's even good for getting clean drinking water from salt water.
Just this morning I went to the neighbourhood Reverse osmosis machine and paid a few cents to fill up my drinking water bottles.
I think it's a great system.
https://www.panna.org/resources/atrazine#2
https://www.theguardian.com/environment/2019/dec/17/rainwate...
https://www.ewg.org/research/ewg-proposes-pfas-standards-ful...
Are you referring to the resources used to create the equipment then discard it when it's done? Or to the wasted water? A permeate pump increases efficiency quite a bit.