Yes dimple piercings do in fact give you dimples. Depending on how long you keep them in.
Does Dimple Piercings Leave Permanent Dimples?
Do dimple piercings leave scars?