John Wilson wrote:
it's on council land

all the neighbours want rid of it

Well, I'd start with a letter to the council asking if it would be possible
to remove the tree.
Perhaps include a map of the area, with the signatures of the houseowners
indicated as to which house they are in, to make it crystal clear.