Water Squares

How can we have squares that can both hold floodwater and act as a community space?