This is the type of material you see on traffic cones, or as patches on safety clothing. Available in many colours; silver, red and yellow being the most popular. If you buy it from an angling shop it will normally be self adhesive.
One strip can do a number of rods. Cut a piece wide enough to just wrap around the tip and about 6″ long. A good tip is to shine your light just off the tape so that it reflects the light cleanly without looking like a fluorescent tube. As an alternative you could whip the top 6″ of the tip with fluorescent thread.

GLOW STICKS SEA COARSE CARP FISHING FLOAT FLUORESCENT ROD TIP NIGHT FISH LIGHTS
£3.49
in stock
Item condition: New
Time left: 19d
Free shipping
eBay
as of 17/04/2021 18:04
100 x Chemical Light Fishing Fluorescent Glow Stick Clip On the Rod Tip TDPRO
£12.87
in stock
Item condition: New
Time left: 10d
eBay
as of 17/04/2021 18:04
50pcs Glow Sticks Carp Fishing Float Fluorescent Rod Tip Night Fish Light
£5.99
in stock
Item condition: New
Ended: Apr 21, 09:02 GMT
Free shipping
eBay
as of 17/04/2021 18:04
GLOW STICKS SEA COARSE CARP FISHING FLOAT FLUORESCENT ROD TIP NIGHT FISH LIGHTS
£3.45
in stock
Item condition: New
Time left: 16d
Free shipping
eBay
as of 17/04/2021 18:04
40Pc Light Stick Clip on Holder Fit Rod Tip Night Fishing Fluorescent Stick
£6.07
in stock
Item condition: New
Time left: 14d
Free shipping
eBay
as of 17/04/2021 18:04
GLOW STICKS SEA COARSE CARP FISHING FLOAT FLUORESCENT ROD TIP NIGHT FISH LIGHTS
£7.95
in stock
Item condition: New
Time left: 1d
Free shipping
eBay
as of 17/04/2021 18:04
Glow Sticks Sea Coarse Carp Fishing Float Fluorescent Rod Tip Night Fish Lights
£13.52
in stock
Item condition: New
Time left: 13d
Free shipping
eBay
as of 17/04/2021 18:04
10Pcs Fishing Light Stick Clip on Rod Tip Night Fishing Fluorescent Glow Sticks
£1.99
in stock
Item condition: New
Time left: 5d
Free shipping
eBay
as of 17/04/2021 18:04
Glow Sticks Box Sea Coarse Carp Fishing Float Fluorescent Rod Night Fish Tip
£3.69
in stock
Item condition: New
Time left: 10d
Free shipping
eBay
as of 17/04/2021 18:04