Modelling the impact of climate change on water systems and implications for decision-makers