Have you check the FPS BP project?
You can also check this tutorial: turret.
The shooting BP logic is the same, the only difference is that in this tutorial he set the sockets in a static mesh, so all you need is to set the socket in the skeleton instead of the static mesh, as Drexciya said, and use the same bp logic.