Shooting is a hobby! You have to pay to play....
Gopher Campfire is not that expensive, but not very much of rifle range length
But is not expensive http://gophercampfire.com/membership/
IRC you used to be able to go into the Little Crow Shooting Sports shop and get a membership.
Rainbow Sportsmans club is not expensive either and it goes out to 300 yds is probably best you can do without going Harris, Elk River, Red Wing or Forest Lake.
http://rainbowsportsmensclub.weebly.com/membership.html
Reality is that shooting ranges are expensive pieces of property. They consume a lot of land. Plus have to have friendly neighbors.
Errant shots do not make for good relationships!
Most clubs with long ranges are meant to be used for competitive shooting programs like Benchrest, F Class, High Power XTC Match and Service Rifle. To go shooting you probably need 2 other people so you can be safe someone to run the target and spotter. No range wants bullets leaving the property!
About the only via option with limited hours for public is Oakdale in the metro. Del-Tone in St Cloud goes out to 200yds. Or Caribou Gun Club down by LeSueur http://www.caribougunclub.com/Caribou_Gun_Club/GUN_CLUB_PRICING.html it goes out 500 yds?
One of the best ideas I have heard is go visit the private ranges when they have their annual public deer sight days. You get to see ranges and find out the scoop. Usually at the big MNWCA show at the Hippodrome on the MN State Fairgrounds most of the clubs have tables set up.
One thing is submit applications now or when then start taking them. I know Elk River does not accept applications till like the first of November. Others have years long waiting lists, ie Dakota County Gun Club. You have to start some time.
Gopher at Harris has a few hoops to jump through so you might want to start laying the ground work.
Erud who posts here once in a while has more first hand knowledge of North Star Rifle Club near Red Wing.
Fairbault Gun Club is not that expensive
http://www.frpcmn.com/range/index.php/membership
Post 435 Richfield VFW has a 200yd range down by Elko. You have to be a vet or family of a vet, but it is not all that expensive.