Hi There,
There is decent shore diving to be had in the Vancouver area and a number of local shops that organize local dives - usually on the weekends.
The Sea Dragon is a dive boat that runs out of Horseshoe Bay (West Vancouver) and the boat dives here are a bit nicer.
The very best diving is to be found on the East Coast of Vancouver Island (Naniamo, Port Hardy - God's Pocket, Victoria). Easy enough to get to on the ferry if you have a vehicle and a number of active dive shops over there to help you out.
Beware - I dive dry all year, even in the summer, but most people are relatively comfy in a 7mm farmer john this time of year.