Deep Cove is on the North Shore of Vancouver. North Shore in "Van-Speak" means north of water, in this case Burrard Inlet. Take the Dollarton Highway exit from the 401 Highway before you cross the 2nd Narrows Bridge. Nice views from the bridge as well, from the car window. Don't stop on the bridge, makes for messy traffic situations.
There's a whole bunch of waterways in Vancouver, mostly interconnected. If you live here it's second nature to understand it all. If you are visiting, it can be a challenge. A map helps. The GPS coordinates help a lot -- for Deep Cove Park that would be: 49 19'38.67" N 122 56'31.39" W. Plug that into Google Earth or a GPS unit and you are there.
Deep Cove still has that village feel to it. Small restaurants and coffee houses along with some interesting arts and crafts stores dot the main street. There is a marina (one public, one private) and a park with paths and trails to stroll along and take in the view. Kayak rentals in the summer.
Lots of seabirds visit here, and even an occasional seal to bark hello at you. And the smell of the sea ... nothing can beat that. Makes your whole day seem clean and fresh again.
The Baden Powell Trail, a 41 km hiking trail, starts from Deep Cove as well, or ends here if you start on the opposite side ... but you know that.