I've found no is pretty much a complete sentence.
Initially I thought I needed to go into some great essay on why I wasn't drinking - I assumed everyone found drinking as important as I did- but that wasn't the case.
'No thanks, but I'll have a water/juice/coke/cup of tea/whatever' is basically all I've needed to say over the past decade of not drinking
D