Hi Sean
Have you tried Ecomarine on Granville Island. I know someone rented a kayak for 10 days from them a couple of years ago.
There is also the Locarno kayak share. Think they also do longer rentals.
Good luck.