Site for UK’s first drug consumption room in Scotland revealed