Packed with happy children, council-run paddling pools and splash parks have offered welcome relief for families from the heatwaves of this summer.