ah so you're waiting on your notice now? brilliant. least we have that sorted.
re drug users: depends what kind of temp accom you are given and as you have disability, which assuming is more than just the usual severe depressive disorder, the council may be reluctant to put you into a place that requires more mental resilience so you may dodge that bullet. yes, if you're in a hotel, you will encounter some drug users and might see the police visiting your fellow dwellers on occasion. requires tolerance and mental toughnness, especially if you have no friends/family immediately available. however, if you don't roll with users they'll very likely leave you alone. personally wouldn't worry about it too much, mind you living tough isn't foreign to me.
should you accept temp accom that doesn't mean you must stay there till you receive an offer for a permanent social home tho; in fact, the council might still expect you to actively seek private accommodation whilst you're there, if you have funds available. frees up social housing for those that do not.
waiting for council housing is longg in general, but not as long if you're actually homeless, as opposed to threatened of homelessness which is your current position should you get notice soon. don't live in your neighbourhood but i would be mentally prepared to be in some form of temp accom for at least 4 months should you go that route.
different from simply being on the social housing list. if you're actually homeless in temp accom the council may eventually offer you
one permanent home once it's available, which you basically have to take if it's reasonable; if you don't the council's duty of care to provide temporary accommodation will end. different from being on the social housing list which has a wider scope of opportunity for housing. i'm sure the council has explained your options tho
https://scotland.shelter.org.uk/housing_advice/homelessness/permanent_accommodation