Firstly - WOW what a cutie.
I love collies, just don't have the energy to own one myself
As said by others I would speak to the neighbours and ask them to bear with you for a week or so, and to let you know if it is to disturbing, definately take a box of choccies to show your appreciation.
If that doesn't work try letting him sleep in your room in his crate until he can go all night, them gradually move the crate back into the dinning room - I did this with my 2 and they slept downstairs afer a couple of weeks.