Car park demolition to reveal first glimpse of stunning city to harbour view corridor