Big water scarcity looms over city