I use
KeePass (open source) and really like it. I use a USB "thumb" drive plus a strong pass-phrase to unlock my password file. It has a decent password generator built in that I have used to create all my passwords.
Before that I used
PasswordSafe but I have not followed the development of that project.