A male psychiatric nurse was found not guilty of misconduct and having a sexual relationship with a woman patient he was treating.