A multi-million pound facility will be manned by medical staff in Glasgow where up to 500 people inject drugs regularly.