Coherence resonance and stochastic tipping points in climate dynamics