Other than Havasu, Mead, and Powell....
Millerton and Bass Lakes near Fresno. Nice places where you can camp and boat.
Lake Oroville, couple hours north of Sacramento. Took me 10 hours to tow there from OC. Camped and boated for 10 days there.
Lake Lanier (sp) in GA is very pretty. I learned how to waterski there.
Lake Piru.... SUCKS... Not allowed in water, 35mph speed limit and Ive heard of a boat sunk on the bottom.
Folsom Lake Ive heard is a dry lake. Meaning no drinky drinky.