What would be the best tape to attach a fishing reel rod?
There is no tape that is suitable for attaching a fishing reel to a rod. You will need to use a rod clamp, which is a small metal bracket that fits around the rod and the reel foot, and is secured with screws.