A mayoral combined authority for Cheshire and Warrington is set to be established, following formal approval by all three local councils.