Hi Katie,
It's a great spot to sail but as Adam said there's nowhere to hire unfortunately.
Closest options would be Jordan's Boat Centre at Port Macquarie (1hr 40min North), or Kite and SUP down here in Newcastle (2 hrs south).
I have rented a SUP from Pacific Palms SUP hire before, they were good to deal with. Maybe just do that instead, at least you'll get on the water.
www.pacificpalmssup.com.au/Cheers
James