Sounds to me like you have your hands full! 
  
Are you still taking this gentleman out of the building for rides daily?  I would be afraid that is only making the situation worse.  He knows he will get to go out if he acts up enough. 
  
What about giving him a daily job to do? IE: passing the mail, hosting the dining room, passing water, small maintenance tasks, takingcare of animals etc....   If he is given a daily task maybe he will feel he is needed and want to stay.   
  
What made him so well known in your town, try capitalizing on that.  As far as him sleeping throughout the morning, is this his pat lifestyle?  If so then your DON shouldn't try and change it, you should accomodate it.  Even if that means your midnight shift providing activity.  How old is this resident? 
  
Hope some of my ideas help.