We found "self-catering" rentals to be the most cost-effective way to stay in any one area of the UK for more than a few days at a stretch. Most were quite enjoyable, too, although we learned to not always choose the least expensive option -- like motels/hotels/any other lodgings, there is a huge spectrum of quality and price. It's been a few years so I don't remember which agencies we used, but a Google of "self catering St Andrews" brings up a number of results for you to check out.

"Self-catering" means it has some level of kitchen and cooking/eat-in furnishings, typically also a living room in addition to the bedroom(s).