The president has signed an executive order rolling back a federal regulation he has blamed for poor water pressure.