Can different user accounts have separate Time Machine Backup drives?
No, because Time Machine works at the filesystem level of the whole disk, not just the files owned by any given user. In other words, Time Machine backs up the entire Macintosh HD, sans exclusions, and doesn't know or care about individual users from this perspective.

Have a look at: How Time Machine Works its Magic