Water storage for streamflow restoration