The Sydney Harbour Bridge will be closed for several hours on Sunday, with warnings of major delays and disruptions across roads and public transport.