If I fulfill my side of the deal, then it only shows up on my criminal record as a Dismissal.
As far as your record is concerned, I think a dismissal looks better on your record than an acquittal. An acquittal is not the same thing as being found innocent; it is more akin to "not proven," but it still means that the prosecution wanted to try the case. A dismissal implies that there were insufficient grounds to prosecute.
The record might in fact reflect a "Dispositional Continuance." For example, in CA, if you go to traffic school, the ticket is dismissed upon satisfactory completion of traffic school. But I have been told that your driving record still reflects the ticket and the fact that you went to traffic school. So insurance companies can see that you got a ticket even though it was dismissed. OTOH, although the official record might show the charge and the dismissal based on "Dispositional Continuance," that might not be available to employers and other members of the public.
Ask your PD about all that. (Hint: we are not your PD.)
Once you have the charge dismissed, with the passage of time, you may be able to get the record of the charge expunged. Ask your PD about that too.