Those programs don't create crime, they're to stop the spread of AIDS and shit from junkies sharing needles. That's all. There are homeless in every big city on the planet, from my experience Vancouver isn't really that bad.
I'd be more worried about Chinese people than the homeless. Homeless are a meme issue unless he plans to live in crack central East Van, which I'm assuming he doesn't cause money is apparently not an issue. Vancouver is pretty clean and safe. You have to look for trouble to find it.