Dave K,
Mark has given you some solid advice.
And i'd also suggest you take a good look at Mark Lund's Guide- it has all the Alberta rivers listed and has good info on different sections of the bow( including the Lake Louise to Banff), Elbow and North Sask as well as the Brazeau, Athabasca and other mountain rivers.
As an Ontarian just returned after 14 years of paddling Alberta rivers, I can assure you there are big differences! Snow melt in the Rockies adds an excitement factor you won't get in Ontario if you like paddling fast water. So carefully pick the river and time of year you paddle depending upon how much excitement you want. That melt also brings lots of crap down with it hence the trees, branches and other junk you'll see in some rivers.
Marks suggestion of Nordegg to RMH is a good one: great river section, wonderful scenery. And Hela can set you up and offers camping and cabins, though Im not sure what their COVID protocol is this year. Keep in mind the Abraham Dam controls flow on this part of river and flow and level can change very quickly.
( we raced this section as part of Alberta Masters Games last August in tandem and Voyageur canoes and it was a hoot!!!!)
Lots of places to rent suitable gear in Calgary: a couple of placxes in Bowness ( Paddle Station and Sports Rent ); U of C Outdoor Centre used to rent tupperware boats, too!
For additional info, reach out to one of the local paddle clubs- Bow waters or Calgary canoe- or try Mark Lund directly through Ceyana Canoe Club in Edmonton. He will steer you in the right direction.
Enjoy
Bruce