An MSP says clubs should pay a "much fairer share towards the costs of policing the public spaces surrounding their stadiums" after costs rocketed.