A flock of sheep in a Welsh village went on a "psychotic rampage" after reportedly eating cannabis plants that were dumped from an illegal factory.