For common household or hobby projects, a basic variable speed reversible (VSR) drill will work fine. For drilling into stone or concrete, a hammer drill is a better choice.
How to Choose Power Drills | Overstock.com
www.overstock.com/guides/how-to-choose-power-drills