Here's a transcription from the link Malcolm posted. The song is in Kate's "Revisited" songbook. It's on her The Wind Blows Wild CD. Wish I could remember where I put mu Kate Wolf CD's, so I could actually listen to it.
-Joe Offer-

RISING OF THE MOON
(Kate Wolf)

The rising of the moon on the Oregon borderline
Lights up the river's edge and the wild blackberry vine
And the sand beneath my feet is a cool silver grey
The moon dances on the water, and then it sails away

And I watch it sail away, somewhere where the river goes
Some love lasts forever, just like the river flows

On the last day of July, you sailed into my mind
We were riding down a river, the wind blowing from behind
There were two great blue herons flying through the trees
Moving up the canyon, so silent and free

And I watched them sail away, somewhere where the river goes
Some love lasts forever, just like the river flows

I hope the years are happy and the winters aren't too cold
And that life won't treat you badly; I'd like to see you when you're old
I'll keep you in my heart like the crying of the loon
And wonder how you are at the rising of the moon

And I watched you sail away, somewhere where the river goes
Some love lasts forever, just like the river flows

---

The song gives me pictures of places I've seen so often here in Northern California. She really captures the wonder of this place.
Now that I live in the Sierra foothills, I realize that I can't think of any good Kate Wolf Sierra songs. She lived nearer to the coast - maybe that's why.