A man who stabbed a popular publican in his home was found not guilty of assault causing harm and aggravated burglary by reason of insanity at Kilkenny Circuit Court.