We stayed in the Intercontinental Moorea Resort & Spa after our Paul Gauguin cruise. This was a great place to unwind (not that we needed more unwinding) before flying home. There's a swimmable lagoon what winds through the chain of bungalows. And the beach offers all kinds of water sports. You won't want to miss the weekly (Sunday evening, I think) Polynesian dinner on the beach. The dancers are excellent. The Intercontinental seems like a good place for kids, too, because of easy to access water sports. BTW, Moorea is right across from Tahiti and an interesting island to visit...lots to see and do.
There're coral heads and tropical fish in the protected lagoon - even the elusive Picasso Triggerfish. What a sight! Nothing better than waking up and taking a before-breakfast swim. You'll need a big one to handle the InterContinental's breakfast buffet! Note: our winter (in US) is their hot, rainy season. So plan accordingly.