If you are interested in training closer to the city of Vancouver, then boundary bay airport is your best bet. I did my private license at montair aviation (www.montair.com) .... but you should really check out all of the flying schools and choose the one that you feel most comfortable with. There are many companies operating out of boundary bay including the pacific flying club and pro vfr/ifr, I believe boundary bay airport even has its own website (search for it).
There is a company in pitt meadows called altair and more out of Abbotsford (which is further from Vancouver) I did my commercial license and muti-ifr at Coastal Pacific Aviation in Abbotsford (www.coastalpacific.com)
As far as safety records go, every flight school in and around Vancouver seems to be fine as there have not been any accidents related to mechanical problems or anything else like that.... that I am aware of.
My best advice is to check the schools out for yourself