There was a VERY cool article about Frank back in Spin magaze, maybe in late '97 or early '98, just a few months before he died. Talked about the man behind the scenes: how at parties, he had several drinks stationed around the room so it appeared that he "drank heavily" so as to keep up that image... and some of those decoys had apple juice in them.
Frank always drank his Jack Daniels straight though, never with water. My favorite quote of Frank's: "Water is no good for you -- it'll rust you out. Hell, even my shower has soda water in it!"
I'm 41 and thanks to my parents, Frank has been a dietary staple of mine for decades. My iPod is loaded with his stuff.