I've tried looking into SPCA for a few years now, the dog companion role is always taken in the GVRD.
I've found this site, but I don't know if anyone has had experience with it.
https://www.parttimepooch.com
Edit: It looks like a site mainly for weekdays rentals. Makes sense since most days people are off to work.