Get Starting location from gun or arrow origin
Get your target like this: Get Camera Rotation > Get Forward Vector > Multiply Vector by float (distance you want to point to) > Add Vector you just multiplied to Camera Location
Note that this makes your arrow point only accurate to the fixed distance.