Newly promoted Wakefield Trinity survive a late scare to beat Leeds Rhinos 14-12 at Headingley on their return to Super League.