Several options...
Narrow River - The only way I know to get is one that I could not possibly describe but I know there is a common access way that many people use, like Saltheart who posts here frequently so hopefully he can chime in.
Scarborough Beach - I have not fished it but it seems to be a popular beach spot
Narragansett Pier - there is a very sweet rocky section meeting the beach at Narragansett Pier. Many people fish the beach front up to the sea wall and I personally have fished along the rock section from the Pier/Restaraunt for smaller keepers and blues (only once this year though). There is a rocky ledge that has good whitewater breaking over it and a section of rocks which you can work and stand on, Korkers Recommended, to get to that area to fish. to the left of that section of rocks is a small pool type area that has held fish in the past for me - no monsters though... Park along the seawall - they two at the pier resteraunt
Pt Judith Light area - Have not fished it before but alot of people fish out of the rocky areas in front of the Light House (I think still under repair with the light section missing) and have heard that many nice fish have come out of there.
There is also a stretch along the East Wall jetty protecting the Port of Galilee that many fish (not sure if much success though)
Of course, Narragansett is not all that far from the Beaches and Breachways either <img src="/Images/biggrin.gif"><!--e7-->
Blitz, I do a fair amount of fishing in Rhody but I will not be able to explore many of the areas I want to learn until I'm living there full time (house is under construction)
Lets get a couple of the Rhody Regulars to pitch in...