The Royal Borough of Kensington and Chelsea announced the decision after 9 in 10 residents said they backed the move