SSRS and Windows should allow impersonation of the user account without requiring "Log on Locally rights"
The advantage of doing this would be that each site collection admin would be able to define data sources without asking the SSRS admin to grant "Log on locally permission"
This will also help in maintaining security of the SSRS server which is centrally managed by IT and therefore it makes no sense from an IT perspective that end users require "Log on locally" permission solely to make impersonation work.