The UK's first legal 'shooting gallery' - a £2.3million centre for drug addicts to take heroin and cocaine under medical supervision - has opened its doors in Scotland.