What type of lens would I?

So am trying to achieve this effect. The type of effect that as you can see here, the beach curves and has this real cool look, I have a Nikon camera, but can anybody give me some suggestions as to which lens I need in order to achieve this effect?

That's a fisheye lens shot that has been cropped.

This photo has a very distorted horizon. You could get a similar effect in Photoshop by playing around with lens correction settings. A lens that would produce this much distortion would be a fish eye lens image converted to rectilinear or a very wide angle lens with a lot of natural distortion.
- I'm in need of a type of a certain type of photography equipment?
- What Lens would be best for this type of photography?
- What type of lens would you use for a moving shot?
- I have a Nikon D40, what type of lens would I use to get my pictures to look like this?
- What type of lens would work best for cinematic filming with a dslr?