Its in the works as of right now.

https://www.kcra.com/article/big-new-california-reservoir-on-track-for-large-federal-loan-sites/39465488

I believe the plan is to use wind/solar to pump water to the new reservoir and then utilize hydro to capture energy from the release.

Another decent project can be found here: https://apnews.com/article/floods-climate-science-business-wildlife-502590d610a78cb027baf260e79b8555

By recreating the old floodplains we can increase recharge while reducing flood risk. The issue with this project is that farmers are reluctant to give up land adjacent to rivers due to water rights.

There is hope, it just requires everyone coming together for a single goal. Ok maybe there isnt much hope...