A popular Sheffield pub, shut for weeks and popular with Sheffield Wednesday fans, is set to reopen.