by which softwares this picture was created? any guess by which software this water is drawn?
If I had to guess, probably Adobe Illustrator/Photoshop... Although there is no way to tell for sure.
Here's some tutorials/examples of things done in illustrator: http://www.creativebloq.com/digital-art/illustrator-tutorials-1232697
Looking at video (e.g. http://www.youtube.com/watch?v=fHuPTEJ9aRc), What I see are two textures: a foreground wave moving left to right, and a background wave moving right to left.
Each "wave" is a ^ shape which is tiled so that placing two copies side-by side shows no seam. They both have a lot of transparency.
The tiles were made using Photoshop probably. The animation itself is probably generated dynamically by the game software.
The lighting effects are done separately and do not appear to respond to the waves themselves they look like 2-3 looped animations which are duplicated and/or shifted randomly side to side and in time sequence.