You don't want to hear divorce, you don't want to hear police. What exactly do you want to hear? The truth? The truth is, he is so in love with an illegal drug that he doesn't want and is not willing to stop. The truth is, your kids should be more important than weed. The truth is, you know EXACTLY what needs to be done, you just don't want to do it. You know you don't like it or how he is when he is high, yet, he uses frequently and he keeps it in the house and you let him. That makes you an enabler and just as guilty if and when the cops ever DO find out and your kids get taken away.
On an another note, the poster who said you should just respect him enough to let him do what he 'loves' is WRONG!!!! You should NEVER 'respect' someone enought to allow them to do something illegal just because they 'love' it! In fact, he should respect YOU enough to know the ramifications that could come of it and NOT do it!
You can't change him, only how you react to him and the situation. You wanted advice, but without leaving or calling the cops, all you can do is accept it for what it/he is, move on, shield your kids the best you can, and hope your neighbors never get upset enough to call the cops.