I have a concrete pit in my garage and it always has 1-3cm of water in the bottom. When I get it sucked out it takes about 3-4weeks before it gets annoying again.

These pits look really good but at a cost I should think. If you can afford it I think these would be the tool.

Happy digging!