Whistler and Blackcomb village have become an all season resort, no longer known as just a ski destination. During the summer months you can hike, mountain bike, ride horses on trails, canoe, fly fish, roller blade, golf, etc. They also have some really high end restaurants and great specialty shops. Whistler and Blackcomb have a really good website to check out:
http://www.whistlerblackcomb.com/index.htm
Are you looking for a local train package? Rocky Mountaineer is currently in operation. BC Rail's dinner train is now defunct.
http://www.rockymountaineer.com/
Yes, to both Whistler and Vancouver, you can take a ride up the mountains to just enjoy the view. In Vancouver I highly recommend taking the gondola up Grouse mountain on a clear evening, eat at their restaurant and enjoy the amazing panoramic view of the city of Vancouver and watch a spectacular sunset over the Gulf and Vancouver Islands.
http://www.grousemountain.com/welcome.cfm
Enjoy your trip to Vancouver and Whistler!
Cheers,
Petra, Vancouver