Achieving water security through climate-resilient infrastructure