Charlotte, N.C., bishop resigns for health reasons; Franciscan named as successor