Sunny Coast ! September is awesome. Water 22 Deg. Ave daily temp around 24.
Consider staying somewhere around the river mouth breaks of Noosa, Maroochy or the outlet of Pumistone Passage at Caloundra. SOme of the places to stay could be Cotton Tree, Maroochydore, Twin Waters, Bulcock Beach, Kings Beach, OR Noosa if you can afford it !
Theres many nice spots for the kiddlys to play while they watch you SUP !