It's pretty quiet and laid back. The zoo is the top draw, along with the beach and being only an hour or so from Disney and the other attractions. There's two libraries to choose from, downtown Melbourne and Eau Gallie (sadly for safety, I recommend Eau Gallie).
Inland is safer (no storm surge) but you can still get major damage and flooding from storms, so I would advise looking at the flood maps and having flood insurance either way, for piece of mind. Homeowners insurance is high everywhere in the state, but that's the cost if you want to live here. Auto insurance can also be high, so shop around for that too.
There are plenty of things to do community-wise. There's the big fair every year, there's all kinds of activities and festivals held at Wickham Park...your weekends will fill up fast

.
If you need anything, give me a holler!