Explain error for when no state changes occur

[igamigo]

After reading through the client code, this is mentioned with a hint on the errors guide. I also reviewed the docs and I think there are a couple of opportunities to add it there, so moving this to the miden-docs repo. We could:

• Add it to docs/builder/guides/pitfalls.md.
• Mention it in docs/builder/smart-contracts/transactions/introduction.md around the failed execution section.
• Add a failure-table row in docs/builder/smart-contracts/accounts/account-operations.md: “transaction produced no state change and consumed no notes”.

Originally posted by @igamigo in #1896