I know you think you've upset your mum and sister but it wasn't really your fault. You said you weren't in control of yourself, was that because of the alcohol?
You don't want your mum to feel low and as you think it's your fault and know you may think that she'd feel better if you weren't there but she would feel a lot worse. She would be even more tired about low if you killed yourself and it would upset your familty so much more.
Is there anyone you can speak to about your plans in summer? If you're feeling suicidal, it's best to tell somebody you trust and who you think will be understanding rather than dealing with these feeling yourself. I know how hard they are and keeping them to yourself will make things seemed a lot worse. Also, if you're planning to kill yourself, it means you can't concentrate on other things you could be doing, such as how to make things seems a bit better.
I know you think you've already upset your mum and sister, but you could talk to them about how you feel bad about it, and how you never meant to upset them which may make them feel better about the situation. Try spending more time with your family and see if the relationship between you improves.
I'm sure there are lots of things you can do right and many people who care about you and would hate for you to feel this way. You said you thought you were a bad friend but I wonder if your friends see it this way. You have friends who wouldn't be around if you were a bad friend. You may feel that you're doing everything wrong but other people won't think that.
Have you read the article about how it would affect other? I think you should take a look (
click). You said you hate upsetting people but killing yourself will upset people more than you could imagine.
I read the line in your sig, and I think that fits. I know things seem really bad at the moment, but there are ways you can make things better. This doesn't have to be the answer.
Take care and keep holding on.
xx