I second the diving in Moorea, or anywhere else in the islands. But snorkeling there is also great, and in many places you can go right off the beach. For example, in Moorea, many people went to the Sheraton resort to snorkel. Not an official excursion, but fun and free!