A popular Sheffield pub is set to close for several weeks before reopening as a restaurant.