Many of the city’s and surrounding towns former bustling pubs have now been reduced to eyesores after lying empty for years but others are set to find new life