If you get Dish Network or DirecTV, the slickest way is to plug an antenna directly into your box. It will query all the channels and add them to your program guide, just as if they were coming in over the satellite dish. I would recommend doing this, rather than plugging the antenna directly into your TV, so you do not have to switch back and forth between inputs on your TV (from satellite box to TV antenna). Also, this will give you the ability to record on your DVR directly from the OTA signal, if you ever want to do that. Yet another benefit to this is, at least on Dish Network, you can record two satellite channels at once IN ADDITION to recording one OTA channel at the same time. You can record three channels at once this way. Or, if your DVR is recording on two satellite channels, you will still have access to watch your local channels OTA without screwing up your recordings. NOTE: I can't speak for DTV, but with Dish Network you do have to sign up for their HD service (an additional $10/month) to do this.
As for antennas, any antenna will work. I have a set of $6 rabbit ears hooked up to my Dish Network DVR and I get all my locals with a signal strength in the 70%'s. I'd like that to be a little bit higher but since I also get locals from Dish Network I'm only using as a backup, so I don't care that much. I bought a $40 Philips powered antenna at Walmart, mounted it on the roof and was disappointed to find it offered no better signal strength than my rabbit ears. So I'd stay away from that one. Terk products seem to have a good reputation.