A major hospital is set to treat distressed and aggressive patients in a new way after a violent incident against its staff bred calls for change.