For unsurpassed singing of Afton Water, on my Decca LP [Hume, arrangement Sharples], it has to be Kenneth McKellar.
This 1959 LP, still amazing quality, has McKellar singing this beautiful Burns song like no other.