A civic emergency has been declared in Cork after it emerged that the water supply to tens of thousands of people won't be turned back on until next weekend at the earliest.