'Drug users' filmed 'shooting up' in broad daylight outside flats before staggering away in trance-like state