Resilient water supply infrastructure is fundamental for human life and wellbeing (Hallegatte et al., 2019). As adverse impacts of climate change threaten the Sustainable Development Goals (SDGs) (UN, 2021), the need for resilient water supply infrastructure is increasingly important if several SDG targets including clean water and sanitation (SDG 6) are to be met by 2030 (Krueger et al., 2020). However, climate extremes, such as droughts and floods, pose a high risk to water supply infrastructure given their proximity to, and dependency on, water bodies