The UK’s first drug consumption room is to be given the go-ahead in Glasgow on Wednesday.