Is there any sleep aids that I can take that will help me sleep at night so when I wake up. I won't feel tired?

Yes. Typically these are not over the counter, however. Most otc medications for sleep are antihistamines and these linger on into the day. Melatonin 3-10mg taken at dark in the evening should not have hangover effects and typically valerian root will not. There are a number of prescription agents that last between 2-8 hours and are prescribed for this reason: "no daytime hangover.".