Mark McNeil: “There was a lot of uncertainty and fear,” but most members of the St. Paul’s Presbyterian congregation have come to accept the supervised drug use site.