Nottinghamshire Police's longest-serving police dog has been retired from the force after more than eight years' service.