Adrian....you are dealing with legitimate mental illness complicated by alcohol.
An extremely difficult situation....that you and the manager are not equipped to deal with....Undoubtedly, other institutions will have to get involved...more than they have....to contain him.
Sadly, he needs treatment and confinement until he can be more stabilized.....
I wish there was more help readily available for situation such as this!!!!
My heart goes out to you, Adrian.....
dandylion