You are asking a question that is just about impossible to answer without a lot more information. it's like asking what camera should I use for professional photography.
What will be your primary client or subject?
Photography or video or both?
What size multicopter do you have? How much weight can it carry?
What is your budget? What can you afford to lose in case of a crash?
What is your normal weather conditions like?
Do you currently have any camera equipment now... Sony, Canon, Nikon....
With this additional information many can advise you as to the preferred camera options.
But, the range of equipment will be from a GoPro Hero 3+ to the RED Epic. The Sony NEX series seems to be a well excepted choice for video and photography.
-Bob
