The Northern Beaches of Sydney hit with heavy floods after heavy rains hammer the suburbs.