The lack of community policing in Scotland is creating 'no-go zones' for the public, senior police officers have warned.