Kicking Horse River near Golden, BC is renowed as the best place for whitewater rafting in the Canadian Rockies, but don't worry if you've never tried it before. Different sections of the river offer different classes of whitewater, so there are various tours and it's a really good time!
There are multiple companies, but we went with Hydra River Guides twice and it was always great!