Suggest me how I can take water drop photo shoot ? Any preferred lens?

A macro lens can help....else try using a prime lens with extension tubes (cheaper alternative, but quality will be compromised)

Prime lenses will give you more sharp pictures. As Vishal said, a macro lens can also help. Use strobes which can freeze the action at faster shutter speed.