I had a water birth with my second child, born this past June. It was fantastic. Don't you worry about your funk, believe me no matter how you give birth, in water, on land, wherever, you are going to have all sorts of funk, and you will not give two hoots about it, if you are even aware of it. Your midwives/doctors/nurses have seen it all and your partner/husband more than likely will also be unaware as he will be paying more attention to a) your pain and b) the coming baby. And as soon as the baby is born, all is forgotten.
If you can get a water birth, go for it. There is something magical about it, and it is relaxing and soothing as far as childbirth goes. I am not sure how much easier it is for a first born, I think that's gonna be tough no matter where as everything is being newly stretched, and I am fairly sure that my labor this time around was much better because it was my second, but if I could have had both underwater I would have in a heartbeat. And if I have another, I will go for the waterbirth again.
Anyway I much preferred floating in the warm if funky water than writhing on the medical bed thing in a funky sweaty nightgown. Even with the pain, it was far more peaceful. You go into your own bubble in labor, anyway.
Good luck!