Yes, Mummies can opt for water births in local hospitals. They are available at NUH, Mount Alvernia Hospital, Thomson Medical Centre, and Raffles Hospital.
The cost differs at each hospital and it can range from $400 to $3,000. This is in addition to the maternity package fees.
Do call up your preferable hospital and I am sure they will be able to better advise you :)