A 32-year-old man has appeared in court following an investigation into an incident that saw six horses and two dogs shot dead in Co Cork over the weekend.