Here are all the drinking fountains in Vancouver according to the Open Data Catalogue (terms). Here is a screen capture detailing how to set this up yourself.

Javascript is required to view this map.