Glasgow had the highest tally of drug deaths with 243 despite the first year of the city’s controversial consumption room