Nobel Laureate Richard Feynman (1918-1988) was the only famous scientist I could find that was teetotal by repuation. Einstein was a moderate drinker, and a heavier smoker. Feynman reportedly used to be a moderate drinker also, no reason why not, but on a trip in Brazil he felt a compulsion to drink alcohol in the middle of the afternoon where there was no social reason to drink. He thought about it, and reportedly never drank again for any reason.
If there was a Nobel Prize for music, Eric Clapton would deserve it. At age 25 he was already hailed as the world’s greatest living blues guitarist. He was inducted three times into the Rock and Roll Hall of Fame: once as a member of The Yardbirds, once as a member of Cream, and once as a soloist. He had a weakness for alcohol and was a long-time alcoholic, but has been a non-drinker since at least 1988.