The £2.3m facility in Glasgow, known as the Thistle, will allow users to inject illegal substances without fear of prosecution.