Drug consumption rooms given green light by top Scottish Gov