That's odd. There should be a script (in the invisible prim over the water) If it's not there perhaps worth picking up a new one (they are in the starter kit plus you can copy one in Mintor)

For the texture, you can find that in the actual water in the 'SF Water Tower' (the one with one water barrel over the other)

Read More...