A NORTH Yorkshire pub has reopened following a £400k transformation.