Faith or intelligence build?

I’m starting a new character and I’ve never played a faith or intelligence build in any of the soulsborne games (besides demon souls) I wanna know which is best for my playstyle I wanna play around with some spells and incantations but also have have the ability to play melee I don’t always wanna just stand back spamming range spells soo which is better to build into a weapon that scales with one of these and also has good spells?