Durham Women's football club's future has been secured after South Shields co-owner Geoff Thompson agreed to acquire a majority shareholding in the Women's Super League 2 club.