A Sheffield pub has re-opened, weeks after a major refit started.