The ‘yuck factor’ was once a barrier to cities recycling water. But technology has improved and the demand for water is growing.