Should my My Book for Mac always remain connected and on?

Will leaving my external hard drive disconnected and off until I really need to make a backup (maybe once a week) help it live longer?

Probably, but most hard drives will go into sleep mode when they are not used.