The Mother's Malison or Clyde's Water is Child ballad number 216, Roud 91.
The Mother's Malison Wikipedia
Willie, against his mother's advice, goes to May Margaret's home, where he is not admitted. He drowns in the Clyde. May Margaret wakes and says she dreamed of him. Her mother tells her that he had been there half an hour before. She goes after him and likewise drowns.sung by John Strachan on Scottish Tradition 5, The Muckle Sangs
sung by Willie Edward on The Muckle Sangs
sung by Stanley Robertson on The Voice of the People Vol 3, O'er His Grave the Grass Grew Green
sung by Anaïs Mitchell and Jefferson Hamer on Child Ballads, released in 2013.