Q&A: What is the best sand for a sand and water table?

I had the play sand final year- and I do not like it for many reasons. It will not hold shapes quite well, it is way too dusty and sticks to my youngsters- huge mess each and every time. They have a sand and water table this year, so I require something that will not be too dusty, that holds sand castle shapes, and that will be okay if it gets a little wet from the water side of the table. Thanks!