'Eyesore' former North Tyneside scrap yard set be flattened