Archbishop Stefan Hesse of Hamburg, a former official in Cologne, is highest-ranking bishop in Germany to offer resignation over mishandling of clergy sex abuse cases