San Francisco will be the first U.S. city with a legal injection site to prevent overdoses; others are scrambling to follow