Cape Town is in the unenviable situation of being the first major city in the modern era to face the threat of running out of drinking water.