‘Maybe the rock’n’roll lifestyle I had brought into Marty’s life was to blame for his plight,’ worries the late guitarist of The Band in this bracing account. Patrick Smith enjoys a window into their decades-long friendship