A new mental health hospital for women has officially opened in Greater Manchester, creating more than 130 local jobs.