I went to Cherry Valley 3 years ago, and am returning this year. The water front is shared with a yacht club, but the scouts wind surf, sail, swim and kayak from the beach. The ACE program, which is designed for the older scouts, includes two organized snorkleing activities. The first is in the cove just north of the camp, and the second is a couple miles south of the camp in a nice spot south of two harbors that you ocean kayak to. Both are nice spots but it is surface snorkeling only, they yell at you if you free dive. I brought my 5mil hooded vest, which made the water much more comfortable.
One of the dads from another troop brought his scuba gear with him, including a small tank (40cuft) and he just signed himself out and did a solo dive just south of camp. He came back with a bunch of urchins which he promptly cut up and shared with the more adventurous scouts. Bringing gear to camp is a bit of a trick because of the logistics of getting it to camp, but can be done. You might be able to work out a deal with the
lds at two harbors to bring you some tanks when they come for the OW programs , so this could work for shore diving.
The camp offers two programs to non-certified scouts. A OW certification program and a Discover program. These programs are run by the lds in two harbors, and are described in
this guide. They don't really have anything official for certified scouts.
I was there with my 14 and 15 year old sons, both were life scouts and not interested in merit badges. I booked equipment rentals and a 2 dive boat dive in advance with the lds. Then on wed around noon we caught the water taxi over to two harbors picked up our gear, and about an hour after we left camp we were in 45' of clear 70deg water over
Eagle Reef in 60' vis. The second dive was at
Bird Rock. Both dives were excellent, with lots of garabaldi, lobsters, kelp, and even a few baracuda. I liked the dive shop, and other most everything went well. We had some equip issues, and would bring by own regs if I were to do it again (generally good advice). We were back at camp for dinner. This option isn't cheap ($80 for 2 tank dive, + rentals, +water taxi) but it was a great memory and fun dives.
As for Cherry Valley as a scout camp, it is by far the best camp I have ever been to. Best activities, best food, best staff, best facilities (especially the troop camp sites - 100% trex decks), best location. As I said, we are going back this year (this time with 2 eagles)
Hope this helps
Rob