Water-scarce cities could get a new source of the precious resource through a simple and cost-effective technology.