I fished the Bow for 8 years before moving back to BC. I preferred fishing below Calgary in the stretch between Deerfoot bridge and Carseland. A drift boat is best but not necessary. If you are prepared to walk there are several(not as many as there should be)spots to park and walk.
You could also do most of that stretch in a pontoon boat, a canoe or you can rent a nice quality rubber raft from the university. Stop to fish every so often in this case.
Like salmon fishing a new place, going with a guide the first day would really save you frustration of searching out fishy places.
Dry line with nymphs/san juan worms under an indicator, big streamers on a sink tip, dries from evening till dark. There can be dry fly fishing in the day time
ale morning dun, blue wing olive, hoppers(August)
Take a 6 and an 8 wt: biggish fish plus often windy.
As mentioned, run-off can impact the colour/height of the river right through June. That said, one June 20th or so evening I caught 15 rainbows and browns to 23in in 2 hours without really moving from my spot except to release them. They will rise to caddis in somewaht cloudy water in certain places.
There is so much river to explore, so many ways to fish throughout the day, plus big fish - I rarely fished the Crowsnest, Oldman, Highwood or even the Bow west of Calgary.
The flyshops should have websites that include the water conditions and the current hatches. That river is the only thing I miss about living in Alberta. It is truly world class.