The consumption facility for illegal drugs including heroin and cocaine is set to open in Glasgow.