The UK's first safer drug consumption room will open in less than two weeks in Glasgow, the council has confirmed.