I don't have experience directly, but I've "looked" at various materials. If I were in your shoes, I'd examine Bain's book Chess Tactics for Students, the workbooks by Jay Stallings (Coach Jay's Chess Academy), Todd Bardwick's Chess Workbook for Children, and Al Woolum's The Chess Tactics Workbook, for starters.
Looking for Recommendations for an Excellent, Not too Expensive Consumable Chess Workbook

Pretty late but I would recommend Chess Steps by the Dutch IM Cor van Wijgerden. https://www.stappenmethode.nl/en/index.php and https://www.chess-steps.eu/home.php .
I have been using it over the years and cannot say anything negative about it. Step 1 and 2 seems what you need. The manual is for the teacher and there are few things that one can learn even if you feel yourself as a strong player. Workbook will be enough for most of the students but hopefully you will have a student or two who will want more exercises. Than the order to go is Extra (which gives more examples), Plus (which adds more material to teach and relevant material), Mix (no hints so the student has to utilize all she/he knows to solve) and finally Thinking Ahead which enforces the student to visualize the moves.

Just discovered the printable, copyright free Teachers Lesson Guide and the matching Student Journal from Homeroom Chess. Looks great. Free. At https://homeroomchess.org/ .
I may have an opportunity to purchase 30 consumable workbooks for our library club which has kids ranging from beginner skills to intermediate (rating around 1200 to 1400). Any recommendations for a good not too expensive consumable workbook ? Thinking of weekly assignments and small rewards for doing so. Maybe it is a book that we use over a few years. Any experience in this area? The difficulty we face is a wide range of levels and maturity from 8 to 18.
A couple of our parents have asked for weekly work sheets but the mentors are thinking a workbook would be a better long term tool for the players(thinking about sheets that get lost vs. a book one might keep).