In a never-before-posted interview with Rolling Stone, the late leader of the Band looked back on his life in music, from The Basement Tapes to The Last Waltz and beyond