This situation needs medical evaluation.
It does not matter if drugs are involved or not.
If he is a danger to himself or others
the police need to be notified.
Especially if he has guns at home.
Stay far away from him
Thank God your sister moved the kids out.