More than a million people descended on Sydney Harbour while Melburnians will hit major CBD celebration zones to watch the fireworks displays.