First and foremost, congratulations!
Second, welcome to the Firing Line.
Finally, if you have some ideas of where or for what department you'll be working for, I'd suggest that you contact someone there and ask about what sorts of pistols are accepted as duty weapons. If there's only one accepted firearm, then nothing we say here will make a hoot's worth of difference.
I'm a lawyer, but I'm not your lawyer. If you need some honest-to-goodness legal advice, go buy some.