Only just stumbled across this thread, and deeply puzzled at the enthusiasm for foot controllers, midi, and DMX.
All these things will eat up your time like you wouldn't believe, cause endless frustration when they don't operate as planned, add to the complexity of your set-up and break-down, and distract you at critical moments when you're trying to play.
For anything up to a large social club, you can put on a "light show" with five carefully-placed lights, or even fewer.
You almost certainly have to have a couple of pole-mounted PA tops anyway, so mount a single LED flood on each of these firing across the band.
Put an LED lightbar on the floor behind the drummer's throne shining straight up the wall.
Put two more LED floods on the floor according to taste and thr requirements of the room, firing up into the dark places around the band.
Don't try to connect the lights, don't try to control or synchronise them. Just set them to flash, either randomly or in a set repeating pattern. You really don't need any more than that.
Job done.
I've bought most of the band's lighting from Thomann and I'm very happy with their stuff. My favourite units are
https://www.thomann.de/gb/stairville_led_flood_panel_150_40.htm (€38 each)
https://www.thomann.de/gb/stairville_led_bar_2408_rgb_dmx_30.htm (€66 each)
So buy four of the flood panels (€152) plus one of the bars (€66) and you've spent €218. You'll need a couple of clamp/brackets for the PA polemounts, which will take you over the limit for free delivery.
I've also experimented with cheap lasers for pub bands. Surprisingly effective BUT only when used in conjunction with smoke ... and the smoke will set off the pub's fire alarm. If you think the landlord gets pissed off when you trip the noise limiter, wait until you see his response when the Fire Brigade turns up.