What kind of lens do I need to take photos of things far away?

I went to Niagara Falls, and I couldn't get in close enough for any decent shots. What kind of lens would I need to take a photo of something far away? Or something really big when I'm close up?