A former North Yorkshire village pub is set to be turned into a house.