Vulnerability and Adaptation to Urban Water Scarcity Outside of Meteorological Drought Events: Updated Perspectives for a Warming World