A popular York bar has undergone a six-figure transformation.