Do you require a well-made round hole, or just hack an opening for something then pour concrete over it?
If the hole needs to be well made, you will need core drill - those are pretty expensive, so you may want to hire a craftsman with proper equipment instead of buying it all yourself for single job.
If you just need a hole, regardless of how ugly it is, a regular rotary hammer will suffice.
When buying, look for two things:
- It MUST have option of chiseling without rotation.
- Read the label and make sure the impact is pneumatic and not mechanical. Around 3 Joules is the standard.
You will find in stores cheap devices that claim to be rotary hammers, but use mechanical impact and cannot get into regular wall. What you are looking for is "big can with a handle" and heavy, not something that looks like regular drill.
You don't need to go overboard on power - 3 joules is standard for the job, 24 joules is a jackhammer territory.
If your local hardware store offers warranty, buy cheaper model that doesnt look like its going to explode in your hands and just ride it to death. Make sure to buy couple chisel bits for it - those can unexpectedly snap, especially if they get stuck.
Important: Wear eye protection. Bits of concrete in your eyes are no fun.
When you have the tool, its just a matter of jacking a hole with it.
Additional safety note:
Rotary hammers of this size and power often do not include safety clutch, and they can and will twist your arm until breaking without stopping if you are drilling and get stuck in a rebar.
My advice is to use your left hand on the button-handle - this way if the device gets stuck but keeps rotating, it will slip out of your left hand and stop since you let the button go. If you hold with right hand, there is a good chance of device jamming into your hand, button still pressed, and that is quite unpleasant and dangerous.