Laying bare the extent of Glasgow's substance crisis, a disturbing video showed the drug-taking hotspot in grim detail with needles, spoons and other drug paraphernalia strewn over the ground.