Water

Is it possible to find a texture that can move outwards from the center instead of one blah direction?

who has the best water textures?

Put it on a sphere.

Or a torus works nicely too.

The linden water textures are actually pretty good. The problem with water is that it's quite layered IRL, you have a surface + reflections, plus various deeper bits you can see through. To make really convincing water in SL you need the layers, and that's usually primmy. You can make faster layers though, a hollowed prim with some texture on the "hollow" face and some other texture on the outer faces gives you a couple of layers quickly. Two of those, suitably stacked, our old alpha sorting problem actually helping in another instance, and you can get quite nice water effects, especially if you put the textures at slightly different angles to each other so they have long repeat times.

wonderful, thank you to both of you

Alternative to already mentioned solution, you can use SCALE mode in llSetTextureAnim() call instead of the usual SMOOTH thing. This can create impression of water flowing either out of centre or towards it, but every now and then you'll be forced to either reverse direction or start animation from beginning, which creates noticeable 'skip' ... so that's hardly ideal.

Circle moving out from center... usable for a fountain or pool

llSetPrimitiveParams([
    PRIM_TYPE,PRIM_TYPE_SPHERE,0,
    <0.000000, 1.000000, 0.000000>,0.949000,
    <0.000000, 0.000000, 0.000000>,
    <0.000000, 1.000000, 0.000000>,
    PRIM_SIZE,<0.010000, 0.900000, 0.900000>,
    PRIM_ROTATION,<0.70711, -0.00000, -0.70711, 0.00019>]);
llSetAlpha(0.50, ALL_SIDES);
llSetTexture("c6184dd8-d68b-fd38-e95a-63c63f94cbf4", ALL_SIDES);
llSetTextureAnim(ANIM_ON | SMOOTH | LOOP, ALL_SIDES,1,1,1.0, 1,0.05);

Square segment, usable for a river.

llSetPrimitiveParams([
    PRIM_TYPE,PRIM_TYPE_BOX,0,
    <0.000000, 1.000000, 0.000000>,0.949000,
    <0.000000, 0.000000, 0.000000>,
    <1.000000, 1.000000, 0.000000>,
    <0.000000, 0.000000, 0.000000>,
    PRIM_SIZE,<1.000000, 0.010000, 1.000000>,
    PRIM_ROTATION,<0.00000, 0.70711, 0.70711, 0.00019>]);
llSetAlpha(0.50, ALL_SIDES);
llSetTexture("c6184dd8-d68b-fd38-e95a-63c63f94cbf4", ALL_SIDES);
llSetTextureAnim(ANIM_ON | SMOOTH | LOOP, ALL_SIDES,1,1,1.0, 1,0.05);

Put either fragment into the state_entry() part of a script on a new blank object. It will change it completely.