A village pub between York and Knaresborough is roaring back to life under new ownership.