Lake Tahoe would likely be suitable. However, you run into similar infrastructure issues once again. It is expensive to build in the area, and any major development will be met with resistance from environmental groups, and possibly indigenous groups depending where you are building. The area has also been fire prone in recent years, so you’re dealing with that threat too.
There are other possibilities in the Sierras and Siskiyous, but you’re likely going to find similar issues. Lakes prone to drought, resistance from environmental/indigenous/farming groups, and a limited pool of local labor and spectators.
Water is a precious resource in California. It might quite literally be “liquid gold” in some ways. There’s hope that some wet years can normalize things, but using housing and water resources to cater to rowing would be highly unpopular in California.