A bishop who was praised earlier this year for his “strong leadership” and “very positive work” by the child safety watchdog for the Catholic Church has decided to resign for health reasons.