Trainspotting author Irvine Welsh has called for the streets of his native Edinburgh to be given "back to the people" on Hogmanay.