The bulk of operations at Sydney Harbour’s last working port will be scrapped to make way for up to 8500 homes built around a metro train station, in a dramatic reshaping of the city’s foreshore that will provide public access to the waterfront for the first time in a century.