>>1 It takes a family to raise a pet. If you had it as a puppy and it's doing these things now, you might not have trained it well enough.
1) Hold a family meeting. You need to be able to ask for help, and if they're not willing to give it, that's something you need to know. Outline what about the puppy you need help with, and literally tell them what you said here: you feel stressed out; despite your research, you don't feel confident that your training methods are effective, you need some help.
2) If they're not willing to be helpful, then you'll need to be more strict and cast away people's judgements. Rewards for doing his business inside, or arriving home to things not chewed up, and a spanking if you find otherwise. If you have a yard, tie him up outside for 15m every time he starts barking. When he does do a hand sign and shout no. If he continues, put him outside or lock him in a room or cage. If this doesn't work, a shock collar. My cat would literally keep me up all night with its yowling, and there was nothing I could do about it. I did research, I did everything I could. I got the shock collar, used it for a month. He finally stopped. If you're unsure of the pain factor, you can always put it against yourself like I did for a test. If you get the right one, it doesn't hurt.
3) Last option; give it away. There's no shame in it. Place in the ad that personal life and school/work started piling up on you, and you no longer had enough time to spend with the collie and believe another family could better take care of him/her. And it's the truth. This won't be the last time you ever have a pet in your life. This was a learning exp; next time you have one, you know what you'll do differently.