I think that as time goes on, a lot more of these medium sized communities where heroin and other opiate abuse is taking hold are going to have to make some decisions regarding safe injection sites and needle distribution.
To the community it should hardly be more than another office building or truck on the street, IMO.
It's certainly preferable to an ocean of used syringes in the gutters and unchecked spread of disease.
Then again, the NIMBY mindset hasn't changed at all over the years.