You really can do it all in Banff National Park, including scuba diving. Lake Minnewanka, just northeast of Banff, Canada, is actually an excellent dive spot.
Lake Minnewanka Boat Tours offers several interpretive tours each day; each cruise explores the history, native folklore, and geology of Banff National Park.