First thing to do is a line pick where the bullet will go. This will determine the normals of the surface the bullet has hit. Use PickedX,Y and Z along with AlignToVector, to rotate the sprite correctly. Then basically fade it after a certain time :)