This often-overlooked Alabama island has all of the amenities of a popular beach destination with a small-town feel.