Try Majorca Isle at Maroochydore. Close walk to Cotton Tree so got surf beach or flat water in the river mouth. Haven't kited there myself due to lack of wind the other week, but seems to be fairly popular when it's on. Or Catalina bit further down the road. There's also a place next to the Majorca - not sure what it's called but will be an even shorter walk.

I've stayed at Majorca and Catalina and both are pretty good.

www.majorca-isle.com/
www.catalinaresort.com.au/

Ben

I live on the Sunshine Coast and can confirm that Cotton Tree will be the best bet. If the wind is good for a downwinder then you are close to the Maroochy North shore which is great for SE SSE NE and NNE - and excellent waves - sorry I can't suggest any accommodation as I have obviously never stayed in any but the ones that the others have suggested look good.