Campaigners are breathing a sigh of relief after controversial plans to build a “geriatric ghetto” outside Aberdeen were sunk by the Scottish Government.