A majority of Sydney councils will welcome proud new Australians with citizenship ceremonies on Australia Day.