Where in particular? North or south of Sydney?

There are heaps of spot around Sydney itself, I am on the north side, so all my spots are there

Balmoral beach and paddle up past the spit bridge
Narabeen Lake
Pittwater from Mona Vale
Bobin head down the Hawesbury River
Cottage point down the river
You can got to Wisemans Ferry and paddle to Spencer. you will need some one to drop you off an pick up. This is around 25kms if you dont mind the longer stuff

North of Sydney there is Ettalong up into Gosford
Bottm end of Lake Macquarie is good

I am sure there are just as many places on the southern side