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