Maybe you should try and work this one out yourself?
Take all the support you need from your friends - I'm sure they're more than willing to help you - and work through the self harm, the drinking, the drug abuse.
That way, you're self reliant, you're in control and it's you that made this change in your lifestyle. If you can help yourself this time, perhaps if you have a problem in future it'll be easier to sort out independantly.
You could always give it a shot and if you feel you're getting no where, get a new councillor, someone you feel you understands better.
Hope everything works out ok