From Providence there’s not going to be much drama, but if we’re really lucky and the weather is clear we may see a smudge in the Western sky just after sunset.
Much more information about comets than the non-astronomer can use is at this excellent site, Waiting for Ison.
Hale-Bopp was visible in my urban sky as a faint glow that I froze my garbanzos to see, and as a horrific weird news story.
If it’s clear I’ll look for Panstarrs over Prospect Park, but likely it won’t be visible over the city skyline– a splendid light show visible every night.
More on Panstarrs with a map of the night sky is here.