If you need to go on short-term disability to treat alcoholism does your employer need to know that this is the reason?

I doubt it - HIPAA privacy and all.

No. Your short term disability insurance company will determine if it is a covered event. All your employer needs to know is that it is a qualifying event. A good HR department would never ask and would not want to know why. There exposure to privacy law violations would be way to high.