This is the current trend in many progressive cities, and so far it's a massive failure. Perhaps it's not surprising that when you work to make addicts happier, you attract more addicts. You also wind up with an entire industry that spends hundreds of millions of tax dollars catering to the addicts, and which perversely needs addicts to remain addicted in order for the industry to survive. The situation only gets worse.
These policies put the addict's needs above those of the non-addicts, since most non-addicts do not want a neighborhood filled with junkies who moved in to get free services, free needles, and legal injection sites.
Common knowledge used to be that an addict needs to hit "rock bottom" before they will turn their life around. If this is true, by making addicts happier and more comfortable, you're not helping anybody.