Plumb_bob,
There are a lot of good LDS's to choose from, I personally recommend The Edge in North Vancouver. They have full rentals available.
As for transportation, it might be a bit of an issue. The common local dive sites are about 25-40km north of Vancouver. Whytecliff / Porteau Cove are...