Is the water by Frank water, a sound FX vst that only has water sounds or does it have sounds that i can actually make music with? I want it, but im afraid that it is only sound effects and not leads that i can actually make melodies with. please let me know.

It is definitely NOT a water sound effects library at all. The sounds are all very very musical and can be used a wide variety of situations such as leads, pads, textures etc and rhythmical grooves that are simply killer and very interesting to say the least.
 
The water aspect does make it's presence felt at times but the sounds are all very very musical indeed. They have just used water as a starting point in many cases to sculpt presets with and they have done it very well too.
 
For example there is a preset that uses an old dis used water tank that must have been very large in size and they are banging things around in this rather incredible environment. No water actually involved there at all but the relationship with water was the tank itself for example. So this is very percussive as you can imagine.
 
And the MixPads offer millions of variations on any of the sounds too don't forget.

One week left for this 'pay what you want' promo:-
http://www.camelaudio.com/Water-Sound-Sample-Library.php
 

dp

Last day
http://www.camelaudio.com/Water-Sound-Sample-Library.php

Camel audio released this statement regarding the promo-
 
"We are very proud to announce the success of our Water Sound Library, in conjunction with FRANK Water.

Thanks to the generous and enthusiastic response of our thousands of Alchemy users, we have so far raised over 30,000 GBP, which will be used to help fund sustainable clean-water projects in developing countries.

Whilst the initial Pay-What-You-Want offer is finished, the Water library will continue to be sold at the regular fixed price of 59 USD / 49 EUR / 39 GBP, with 50% of all future sales donated to FRANK Water.

Water for Alchemy Mobile is also available for for 4.99 USD as in in-app purchase, and 50% of the net proceeds are donated to FRANK Water."