Probably the best place to start planning what to do is the official tourist website which has loads of information to help you plan your holiday.
The Carte Loisirs gives you access to the ski lifts, many free activities, and discounted offers. Buy one adult card and get a child's card free of charge. Cards are valid from 1 day to 15 days.
Many of the activities are organised by Kamelot Camp from four locations in Courchevel (Place du Tremplin), Moriond (Plan du Vah), Village and Le Praz. Some activities are organised by Chardon Loisirs
Some brief examples are shown below, but check out their websites for more detailed information
If you travel down from Courchevel Moriond towards Courchevel Village, you will find a water complex called Aquamotion, which was opened in December 2015. This includes a swimming pool, an outdoor pool which also incorporates a 'lazy river' pool, 110 metre flume, jumping pool, and saunas/jacuzzis. There's also a surfing pool (prior reservation required), and an indoor climbing wall.
If you're visiting with children then you'll be heading straight to the 'Espace Aqualudique' which is a huge area with lots of places to explore. There's a colourful children's area with squirty flowers and a fun slide for the littlest swimmers.
'Serious' swimmers have a 25m lane pool. Exercise classes are run in this part of the pool, such as aqua bike & aqua boxing.
For lounging around, there's a main pool which is lovely and warm and at a standard depth throughout, with bubbly bits at one end and shoulder/neck massage showers. The heated exterior pool is separate to this - you enter on the inside then swim through to the outside, where there are several fun areas such as relaxing bubbly lounger spots, power massage showers and a 'lazy river'. This outside area is lovely even when the snow is falling gently around you, just dunk your head every so often to keep it warm!
Inside, there's a large red luge (hold your nose as you come into the main pool!) which anyone over 1.2m tall can use. There's a 'pentagliss' slide which is fast and furious - anyone over 5 can use this slide. There's also a diving pool which has a small jump and a much higher one. Anyone who dares is allowed to jump, children included!
For grown-ups (over 18) there's a separate 'Espace Wellness' with a darkened salt cave with chromotherapy lights and a projector (yes, really!) You can float around and watch the atmospheric films.
There's a main pool which is both interior and exterior, with bubbly bits and water jets. The sauna and steam room are in this area, with a plunge pool to cool down after your heat treatment.
This area is specifically designed for fun! Water jets allow activities such as wakeboarding, wake surf, wake skate and bodyboarding.
As you'd expect, there are all manner of relaxing options on offer in the Balneo & Spa area - facials, massage and waxing - as well as aqua treatments such as 'hydrojet' massage, seaweed wrap, hot and cold water baths and very fine 'rain' treatments. Prices start at €28, or you can choose from day passes which start at €143 and include various options from the treatment menu.
If you're thinking of going more than once, then there are 18 hour passes available.