Your ONLY real option with public transportation convenient:
Liberty Harbor RV Park
What dates are you going? The Pope will be in town towards the end of September, the Giants AND Jets are home that weekend too. That will make a bad traffic and mass transit situation worse.
There are other camping options if you want to drive your toad closer to the city and take a bus or the PATH train.