In second-order logic (with standard semantics), we know that there are sound deductive systems, and we know that no sound deductive system can derive all true statements.
I was wondering whether there was a formalized sound deductive system which could be used as the basis of a "unique" computable algorithm to prove all sentences provable by humans, say in a mathematics textbook.
Is there for example a sound deductive system which can prove every sentences that are provable by at least one sound deductive system ?
Examples of such eventual real-world deductive systems (for instance used in HOL theorem solvers) are welcome.
A statement cannot be not just "provable" or "not provable", without further specification. It is provable in some specific deductive system or not.
So your question has a trivial answer: Yes, any sound proof system can prove exactly those sentences that are provable in that system. And that is the only form of "provable" there is to ask for.
(Note that a "deductive system" is exactly the same as a proof system: a set of rules for what constitutes a valid proof. It looks like you may be thinking that a deductive system has to be an algorithm, which is not the case -- though, of course, once you have defined a deductive system there's an algorithm to find proofs in it; if nothing else, there's the brute-force one that searches through all proofs in the system and looks for a particular conclusion).
Furthermore, every logically valid second-order statement is provable in at least one sound (and recursive) deductive system. Namely, we can just declare it to be an axiom and add it to a known sound system. So you can't get a sound (and recursive) system that will prove everything every other sound (and recursive) system can prove.