Everytime you get out of bed to let Drake out, you are reinforcing his bad behaviour. Quit letting him in and out! If he sees something out the door then make it so he can't. When he barks give him a firm command to lie down. If he does then reward him. If he is quite for a few minutes you can reward him. Slowly increase the amount of time he is quite with a reward. His reward can be a biscuit or something he really likes but don't reward his bad behaviour by giving him what he wants.

After a few nights to a week at most he should realize it doesn't do any good to bark and carry on but when I'm quite I get a treat! You and Andrew are going to have a few rough nights but it will pay off eventually!