Perhaps the easiest way would be to get a cable from a parts yard and attach it to the speedo....and use a drill at the transmission end to spin it.
Otherwise you need to know the size and shape of the cable end and replicate that with a drill to power it....