Councillor Kate Knight resigns from Labour Party and council’s Labour Group following posts on social media