Last Summer I joined Ecomarine on a monthly basis. It was awesome because it was so cheap to get out and just paddle from Granville Island or Jericho. This allowed me to try all sorts of boats and even go out in a double with a friend (additional charge) https://www.ecomarine.com/membership/
For club trips I pretty much used MEC and Ecomarine but for the Navigation Coarse I rented on Galiano Island.
Here is another option.