Modelling the future water infrastructure of cities