A popular pub in Carlisle has officially reopened.