Hi SallyDZ,
Yes I would really recommend it. The pool is perfect for little ones; mine loved it, and they re 10 & 12. It is about adult knee height at the deepest, and is made from soft rubbery stuff, so you can't really hurt yourself. There are deeper, traditional pools too.
(see link and click on the pool picture)
www.canvasholidays.co.uk/campsite-overview.aspx?id=TO06Y
There is everything you need on site. Supermarket, bars, bike hire, ice cream bar, washing machines.
The beach is near, but not great for little ones; it shelves steeply.
If you go with Canvas, they have great kids clubs and also family activity plus, which is snorkeling, raft building etc, but with such little ones, you may not use this. Mine loved it. (See link)
www.canvasholidays.co.uk/campsite-activities-and-entertainment.aspx?id=TO06Y
The site is very big; there is a fair bit of walking especially if your caravan is a long way out. It is worth hiring bikes if you get one there. I think you can get them with baby seats on.
Hope that helps.