Regional impact of climate change and variability on water resources