I would say definitely have it be an option (get a room with a pool in it if you decide to birth in a hospital) so you can have it as part of your tool kit on the day. I always planned to have a water birth (though at home) and had a birth pool set up, but found I actually wasn't as comfortable in the water as I'd hoped. I'd been joking all along how I might hate it because I don't really like baths or going swimming. Turns out I really didn't like it as much as I'd hoped! But I think this has a lot more to do with waiting until I was pushing to get in and with the water not being as warm as it should have been (we have a very old boiler that doesn't work very well). I ended up getting out and giving birth on dry land, but I'd like to try again next time to see if I like it more. Water is excellent for pain relief (I didn't really find birth to be all that painful and didn't even realise I was fully dilated when I was, so I think this is why it wasn't as amazing as I'd hoped) and if it helps you avoid any interventions you don't want to have, then it's a great thing to try. I'd highly recommend at least giving it a try.