Supervised drug-use sites scare a lot of voters, but they’re one of the best ways to tackle a national overdose crisis