Unity procedural textures

Question

I'm wanting to have an object that does random animation in Unity, within the object. Basically, I want a floor that has lights that go through it. I'm trying to figure out exactly what is the best way to make that happen. I know there is such a thing as "Procedural Textures" in Unity, but I'm struggling to understand exactly how to make these textures. There are two basic ideas which I have:

1. Attach a script to the object that I want to place the texture on. That class should manage the texture in all senses of the word. This seems clunky, because it won't show up in the scene mode. This texture would then be assigned in the Start() function for said script.
2. There exists tools that make these procedural textures, such as Substance. Currently I don't have much of a budget for game development, so I'd like to stay away from anything with a cost (This is more of a hobby for me right now).

Is this the correct way to think about things, or am I missing something fundamental? There seems to be procedural materials that I can't quite understand how they work. Am I missing something else? Thanks!

EDIT:

What I'm trying to do is to have moving lights go across a floor, either as a part of the floor, or even as contained within the floor. I'm considering using some kind of particle system for it, but I've heard about these procedural textures and I thought it was worth a shot to see if they do something similar. I'm also considering using a randomly generated star skybox using a similar method. Specifically, I'm picturing moving lights going across the floor in this image.

Answer 1

It turns out that the trick was to simplify. @Phillip provided me with a trick, that the easiest thing to do was to create a series of small moving lights, that only rendered on the floor. This creates the moving lights that I was looking for. This shows what I was looking for.

How I achieved this:

1. Create a game object that periodically creates small light sources that move just above the floor.
2. The floor was already on it's own render layer. I specified the light to only affect that layer. I might change my mind on this later, but for now, I like the effect.
3. Apply a slight velocity to the objects, some random color, and away they go!

The code looks something like this:

    GameObject obj = new GameObject();
    obj.transform.position = startLocation;

    Light light = obj.AddComponent<Light>();
    light.type = LightType.Point;
    light.intensity = Random.Range(probeMinIntensity, probeMaxIntensity);
    light.cullingMask = 0x1;
    light.bounceIntensity = 0f;

    Rigidbody rigid = obj.AddComponent<Rigidbody>();
    rigid.useGravity = false;
    rigid.velocity = new Vector3(0, 0, 1);

Of course, there's still more work to do, but this was more than enough to get me over the hurdle. Thanks!