Philip O’Connor looks at a city’s attempts to take drug users off its streets through a ‘fixing room’ with hygienic facilities, meals, beds and treatment programmes