A couple have spent £50,000 transforming a derelict water pumping station into a luxury countryside getaway popular with celebrities.