Spectacular new life has been given to one of Sunderland’s once-lost city centre pubs.