The Magpie pub will soon open in Newcastle city centre as a recently shut down bar gets a new look and a new name