A priest who was acquitted in 2012 of sexual assault charges has resigned from ministry in the Diocese of Derry.