Sports enthusiasts and lovers of the great outdoors have helped an Arran campsite win a top national award.