Where will you be having your bub OP? If you are going through a community midwifery program, or having an independent midwife you may be able to build a relationship with the middy that will be with you so that you can relax in the knowledge that they know how you are feeling and will work with you.
Birth skills bu Juju Sundin is a really good book.
Some birth videos are better than others. The birth that I can think of off the top of my head is Lydia in One Born Every Minute (UK) - hers is amazing and, to me, I want one just like it.
Don't let people tell you their horror stories. Women love doing this but if they start, just cut them off and say "I'm sorry, but I know all the negatives, I need to hear positives now".