Rental property around here gets scooped up very quickly. Actually, any property really whether rental or purchasing, goes fast so I'd start looking for somewhere to rent a little bit before you plan on actually moving here. It's definitely what they call a sellers market which has been difficult on buyers/renters, at least everyone I know has had a difficult time.

Other than that, all the places everyone mentioned are great places. I saw someone mention Morris Cove which is really a great neighborhood but prob more suburban than you're looking for and there's no bars/restaurants immediately nearby within walking distance. It was a very Italian neighborhood at one point but has changed a bit so there are a few small markets but that's it. East Rock is probably more what you're looking for.