R.A.
I would assume that he should probably work with a addiction counselor on an outpatient basis weekly for 3-6 months, and then monthly for a year after that. He should attend a NA meeting daily for the first month of sobriety. This will help him through his withdrawls, and to talk to others who are working on their own sobriety.
For you, I would find a local Alanon meeting to attend. This will help you as well as talk with other family members and friends of someone who is going through and addiction.
At times, when someone is going through a heavy addiction they will need to be admitted for a 28 day rehab program. If that is the case, then there he will go through the withdrawl periods, as well as work on recovery there. It usually is the best way to go, as he will be in a safe place with trained staff. Do not be alarmed if this happens. It is part of the process.
I have to commend you for offering your support, love and encouragement. It isn't easy for someone with an addiction to come clean and be open and honest about it. The fact that he has asked for help and recognizes he has a problem is the first step. Good for him.
I have worked with many clients who struggled with an addiction to alcohol and drugs, as well as mental disordes. If you need advice or anything, don't hesitate to message me on here.
Added: Yes , absolutely their is hope. If he finds a good treatment program and counselor, and is willing to work at his recovery, their is hope. I have had many clients who are in recovery from their addiction for a long time.