Private equity firm Tailwater Capital LLC has committed to investing more than $500 million to Goodnight Midstream, a company that builds and operates midstream oilfield water infrastructure for producers.