I can recommend two books. Guitar chord guru, and guitar scale guru. Both are by Karl Aranjo. These books work together. I suppose it depends on what type of guitar player you want to be. If you only want to play rhythm, then the chord book is a good place to start..but then, eventually..as most guitar players do, you will want to incorporate a few lead licks..or maybe move on up to playing lead.
These books work in conjunction, and if you honestly study them, and spend a few hours/day..i can promise you will improve, your confidence level will be boosted. Confidence is a key factor, and a cornerstone of really good playing.
I have played for thirty five years, and i still reference these books from time to time. The later chapters will take you into different modes. lydian, mixolydian, etc.
These are very well written, instructional books, and something every serious guitar player should have in their arsenal.
I'm not sure the cost of these books anymore, but check with your local book store.
One thing i will add, tabs are cool, but not always correct. There are a lot of helpful videos on you tube.
Another thing to remember, don't let it become work, play what you like, learn when you can, and above all, have fun with it.
Some good advice, but I would add that it tends to make a player more versatile if he learns the formulae for the modes and scales rather than simply learning the positions.