First, Congratulations on your child. May you, your wife and the newborn be blessed with a holy Catholic life.
To your question: No, both Sponsors or Godparents for Baptism must be faithful Catholics.
You can have:
- One male Catholic
- One female Catholic or
- one of each; a male and female Catholic
Make sure you read the appropriate section from Canon Law (below) on the Vatican web site for all requirements.
Also see the question we answered below.
If you are having trouble finding a faithful practicing Catholic, talk to your local priest and ask him for some people who could help be a good role model for your son.
I hope this helps,