Scottish Government officials have backed plans to redevelop the former Helix Offshore site near Dyce - despite the local authority's fears it would cause too much traffic in the area.