For boaty families, check out the Bahrain Yacht Club and Marina over in Sitra. The sailing club is built around a small lagoon with a beach, which is a good quiet spot for children to play. There is a good swimming pool and lounge area too.
https://www.thebahrainyachtclub.com