Congratulations!! And yes you will be deprived of your sleep. You will get used to it. I am the father of 4 and have had many nights of no sleep. Nothing however compared to my wife, due to her having the milk. You just have to deal with it and turn off the tv and go to bed early if you want to maintain your sanity. I would not advise the use of any boosting agents as that will just tap your natural reserves even more and you will pay for it harder in the long run.
Rule #1 for getting sleep. If you are home with the baby and the baby is taking a nap and you are tired as well..............join them. take a nap whenever you can, I found this to really help when I was home from work on the weekends.
If sex life becomes an issue then make sure your wife does not coddle the baby all damn day long as the baby will never want to be let go. there comes a time when you just have to put the child in the crib and let it cry itself to sleep. this may take a few hours each night for up to a week. But they will learn and your nights will be much much better.