We went to a counselor for that very reason: to figure out how to tell the kids that we were divorcing. My counselor said that kids even the ages of my children; 8 and 10 should be told the truth about the alcoholism. He suggested; "Your dad has a problem with alcohol" "He loves you both very much" etc, etc.
Honesty is the best I believe.
Good luck to you.