An NPPL with a SSEA rating will allow you to fly as a tug pilot, but you will need a tailwheel endorsement to fly Lakes GC's Super Cub.
The problem you might have is that gliding clubs prefer to recruit their tuggies from within the club; they are unlikely to let an outsider with no gliding experience fly for them.