Which dog breed is known for its exceptional intelligence and versatility in various roles, including herding and service?