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.
I wonder if there's a startup (or multiple) here? If you take GABA supplements it has some minor version of the affect of alcohol, and if I remember correctly alcohol is a GABA inhibitor. Is there a way to engineer a better, safer, equally or more enjoyable alcohol, maybe with less judgement impairment?
But getting a recreational drug « approved » for sale is difficult. But maybe not impossible.
And chances are the attributes that make it relatively safe in 500mL-beer-equivalents probably make it possible to consume 10x amounts for 10x pleasure but still 5x worse negative effects than that 500mL beer.
Alcohol’s side effects contribute to its self-limiting self-administration for a good chunk of the population.