Creating a game from scratch

Hello! I am new to Unity and I have been following the Project Tutorials for a while now. but recently I started thinking about making my own game, a space shooter actually. But I can`t figure out how to crate the Art Work. Does Unity provide some Designer Tools as in making my own ship with their respective shapes, my own artwork, sounds and so on or do I have to use 3rd party software?

I do not mind working with other software but what can I use to create for a example a ship similar to the one in the tutorial? Also, do you guys know what tutorial I should follow on creating textures?

P.S.: I have some background in Fusion 360 and Graphic Design...i just don`t know what software to use in this case.

Thank you for you time! I hope my question is not too ambiguous.