Some evaporates. It will eventually come down again as rain somewhere else but as far as the original city is concerned the water is used.