How about passive rain / fog collectors at the top of the buildings? Unless your post-apocalyptic city is Las Vegas... Fog collectors are large permeable fabric panels that intercept the flow of fog-filled wind on hilltops and ridgelines, and collect hundreds to thousands of liters of water per night. Fog collectors have been erected in Namibia and Peru to provide water for personal needs, cooking, and agriculture.