Neighbour row diffused by council after bosses agree to give artist space to exhibit his ‘rubbish’ sculptures