You will often run into snipers throughout the game. They are hiding in guard towers. When marking them with the binoculars or drone, they have a different icon (orange crosshairs) than normal enemies. Equip the pistol, then kill a sniper with it to get the "With A Pistol!" achievement. You can run straight to a sniper and kill him; it does not matter if you are detected or not.