I haven't had a waterbirth yet, but I have heard great things about the "Fishy" pool. Everyone that I have talked to has not had issues hanging over the side of the pool.
My midwife has this one that they use:
She said that its great for leaning in the edge. I was concerned about the pools without a heater but every midwife that we interviewed said its never been an issue.