Water tight: infrastructure planning for a climate-resilient future