Longstanding landlords of a much-loved North Yorkshire pub have stepped down “with a heavy heart” after more than nine years.