A North Yorkshire village pub once visited by Princes William and Harry is set to re-open next month.