Will a hammer drill also fix screws?
A 10.8V/12V battery-powered combi-drill with switchable hammer action will satisfy most of your occasional DIY light-duty tasks and will not be heavy to hold for extended use. It will probably struggle a bit with larger holes in masonry but if you only do a little of that it will be adequate.

Usually there is a three position switch:


screw-driving (with variable torque-limiting clutch)
drilling (with variable speed controlled by the trigger)
drilling with hammer action (masonry bits recommended for this)


Most drills will have a speed switch with two positions. Use the lower speed for larger drill bit sizes.


Example name-brand "pro" product available in UK for around £75, The Lidl "high performance" brad-point drill-bits are a real bargain too

If you expect do a lot of drilling into masonry, a mains-powered hammer drill is probably a better choice for a low-cost tool.