If you want a snake that sits still and enjoys the experience you can't beat a ball python.
If you want a snake that wants to go-go-go and rarely sits still, then a corn snake fits the bill.
Corns are sweet but kids tend to lose interest fast when the snake won't sit still