All the obvious ones have been said, so I'll add this:
Make some phone calls or drive out to Springbank airport and find a flight school or flying club that can take you up for a tour of the city or the mountains from a plane or helicopter.
It may be a little more pricey than other activities, but I can promise the views will be incredible, especially of downtown or flying into the mountains.
Most places call these flights "discovery flights", I did a bunch for people when I was a flight instructor back in 2002-2004. Quite a few were for tourists or visitors that wanted to see the sights from the air. Average flight was about an hour long.
Edit: Here are some links:
http://www.springbankair.com/index.asp?view=sightseeing
http://www.mvheli.com/tours/index.aspx
http://www.flyright.ca/contactus.html