A family is to sell a popular Scottish village pub after two decades at the helm