You don't have to have a hammer drill to drill masonry. The hammering process helps the bit not get stuck as readily, but they do make masonry bits for regular drills as well. Note the double-flute of this one, compared to the one Tester posted. I think Vermont American might be the only brand to make these (I've not seen any other brand for standard rotary)
Still, hammer drills are best for this. I have a really basic hammer drill from Harbor Freight (the cheap non-branded one) and it suffices for the small projects I do here and there. If you don't do this often, Harbor Freight can be your friend for light duty niche tools like that. The main advantage is that most masonry bits are meant for hammer drills, so you can easily find them. The big boxes tend to sell the rotary ones as well, but smaller stores don't.
I would highly recommend the Tapcon brand for regular mounting. They have a special screw for masonry that requires no anchors.
They also have specific sizes matched to the masonry bits they sell, so there's no guesswork in what size bit you'll need. I've been able to mount a wide variety of things to my brick siding using these and nothing else.