Assessing the risk of water supply in drought-prone areas