Assessment of risk to water resources in the light of climate variability and compounding urbanization