What are the skills necessary to become a successful community police officer?

Community Policing is a kind of 'sub-specialty' of regular law enforcement operations. You would need the same skills necessary to get you hired on the job in the first place, plus the demonstrated ability to easily relate to the community you would like to serve.