Great location- no, you do not need a car!
We even went to Capilano Suspension Bridge using ferry and bus.
The views from the massive windows are fantastic.