The lyrics you recall match "When You Least Expect It" by George Strait (from Lead On, 1994). Key lines:
"I'll be the wind in the rain, when your face is cold and wet
I'll be the whisper in your ear, when you need a soft word yet
When you least expect it, I'll be there
Like a guardian angel on a cloud, I'll be anywhere"
The song is a tender assurance of constant, unseen presence. Written by Dean Dillon & Norro Wilson.