One of the world's iconic tourist destinations could run out of water by April as the city's worst drought in a century risks forcing residents to join queues for emergency rations.