Water Birth

Has anybody had a previous experiences with water births? This my first time pregnancy, I would like to do a water birth or just labor, but not at home.  Has anybody had a water birth in a hospital setting?   If so do  you had any light Meds to ease the pain while enjoying the water for laboring? I haven't really look into a birthing center but I don't think they do pains Meds if I change my mind. The only reason I want do one in a hospital if for some reason something happens for emergency. Not really up for C-section but I will consider it as a very last resort or for emergency.
I'm open mind and looking for some suggestions.