This is why Housing First is such a brilliant idea. Give them help, but require them to be stably housed (i.e. on a viable path out of long-term homelessness) before they can access the help.
Fast forward five years, the place is a shithole. Roach-infested, apartments severely damaged and filthy, needles and garbage everywhere. Police, fire, and EMS spending a disproportonate amount of resources there.
People who are chronically homeless and addicted do not know how to live in houses. If you give them housing they will destroy it or they people they associate with will destroy it.
Sobriety has to come first. Some people won't accept that. At some point you have to stop accomodating their behavior and just say "no, that is not an acceptable way to live, and you can't do that here."