This is definitely a Unity question. You should look up Unity tutorials on what's called a "paper doll" system. You'll need to understand how to attach different frames of the weapon sheet during each frame of an attack animation, and have those weapon sprites display at the right position, rotation, etc, based on whatever kind of attack you want to make.