Dowie here has nothing to do with the surname. Dowie is simply a Scots word meaning dismal or dull. A den (or dean) is a narrow wooded valley. Hence if the phrase is read literally it means "dismal valleys of Yarrow" Dismal in this context meaning sad.