Go-ahead to transform ‘eyesore’ land once home to cannabis farm and stables