Depending on how many holes you need to drill, either a hammer drill (good for just a few holes), or preferably a rotary hammer drill (this is a lot easier, and can be used to chisel up tiles and concrete etc) .
Just head down to Harbor Freight or Walmart and ask their experts.