The Rocky Mountain Parks (Banff and Jasper) are a famous destination in Alberta, but if you are looking for something a little different and out of the way, there are some real gems in the foothills. The strong structural controls from the tilted sedimentary layers makes for some absolutely incredible rivers and waterfalls draining the foothills. Resistant layers of rock can impose ‘knickpoints’ on rivers and cause waterfalls and steps in the bed, and the foothills of Alberta are rife with wonderful examples. Living on the West Coast now with its metamorphic rocks (hey, no value judgments), I really notice what a different quality the rivers in Alberta take on from their sedimentary origin. The many provincial parks in the foothills get overshadowed by their mountainous neighbours, but the rivers and waterfalls there are second to none.
I suggest driving Highway 11 from Saskatchewan River Crossing to Nordegg and then South down the Forestry Trunk Road to do a tour of some truly incredible rivers and waterfalls. The campgrounds and roads are also less busy than the Mountain Parks, and if you are interested in hiking you can really lose yourself in the protected areas along the David Thompson.