Unfortunately not something that's within the power of the Scottish Government to enact, as it is a "reserved" matter - a legal power not devolved to the Scottish executive.

There is a strong desire for "shooting galleries" in Scotland (safe spaces to take drugs where help and clean needles are available) but the UK government and the Scottish government have very different policies on drugs.