Campaigners welcome Sturgeon's 'Scottish Green Deal' pledge but urge real and radical follow through