Ministers have announced two more major devolution deals, under which city regions will receive housing powers in return for adopting an elected mayor.