First of all, if the black hole is not actually in orbit around the Earth (or, technically, both it and the Earth in orbit around their common center of mass) then, as other commenters have said, it will fall through the Earth, pop out the other side, oscillating back and forth, eating whatever particles it comes into contact with. One of two things could happen, depending on how big it is to start with: either it doesn't eat enough matter fast enough to keep from eventually evaporating, or it does eat enough matter to keep from evaporating, in which case it starts growing larger, unstoppably, and eventually consumes the Earth.
To get a handle on black hole sizes, a black hole the mass of the Earth would be about the size of a golf-ball, and would probably not evaporate for billions of years. A black hole that evaporates in a few seconds or minutes might have the mass of an aircraft carrier, and be a millionth the size of a proton. Caveat: When you discuss things that small, quantum mechanical effects come into play, and the relationship between quantum mechanics and relativity is still poorly understood.
Let's assume that (1) the black hole is small enough to evaporate in a reasonable time (which means it will be too small to see), and furthermore, that (2) we've found a way to contain the black hole above the ground. There are a couple ways I can think of that might be able to contain a black hole. We've already discounted the idea of placing it in orbit (or placing it near a Lagrange point). But black holes can have an electric charge, so we might be able to use an oppositely-charged electric plate beneath it. Momentum can also be transferred to a black hole, so imagine we can use a sort of relativistic particle fountain to hold it in place. This would be like placing a baseball in a high pressure water fountain to hold it up. Only the baseball is microscopic, and weighs more than an aircraft carrier, and the water fountain is a stream of plasma moving at a substantial fraction of the speed of light. I'm not going to do the math to see if that's plausible, but let's pretend like it is! (Let's also ignore the fact that by feeding the black hole, we are causing it to grow, and prolonging its life, which will probably doom us all.)
Under these conditions, what might happen? With such a small black hole, you're generally not going to feel much acceleration from the gravity unless you get really close (distance TBD), but at some point, very close to it, there will be crushing tidal forces.
What I haven't seen anyone discuss is atmospheric effects. Assuming your black hole isn't contained in a vacuum, it will probably start sucking in the atmosphere. Caveat: I have no idea what happens when a subatomic particle hits an event horizon one millionth its size, but I assume the matter will somehow end up collapsing and compressing into the black hole due to tidal forces. I'm also not sure how quickly the atmosphere (at atmospheric pressure) will be able to "drain" through such a small hole. Given that air has weight, and is attracted by the earth's gravity, the air in a column above the black hole will find itself rushing downward, into the top of the black hole, creating a small low pressure area above it. But as the air rushes in towards the black hole, it will probably exceed the sound-barrier, creating a constant sonic boom, that rumbles like a continuous thunder. Due to the Coriolis effect, it will spiral around the center, like water down a drain, possibly creating a rapidly spinning cyclone of air (think of an extreme low-pressure zone). As the air gets highly compressed towards the center, it will become super-heated, and ionized, which will create an accretion disc. As this plasma ignites in fusion, and approaches the speed of light, it will probably emit considerable radiation.
Again, I'm not sure how pronounced any of these effects will be for such a tiny black hole. If it evaporates quickly enough, its possible that none of this will become very bad, or it might take place on such a small scale that it's hardly noticeable.
Best case scenario: we get an awesome roaring cyclone of plasma that doesn't kill us with radiation, crush us with tidal forces, drain the atmosphere, or eat the earth before it disappears. But that's probably too much to ask for.